<?xml version="1.0"?>
<?xml-stylesheet href="chrome://global/skin" type="text/css"?>
<?xml-stylesheet href="chrome://mochikit/content/tests/SimpleTest/test.css" type="text/css"?>

<!--
    storage listbox with query parameters
-->

<window title="XUL Template Tests" width="500" height="600"
        onload="test_storage_template();"
        xmlns="http://www.mozilla.org/keymaster/gatekeeper/there.is.only.xul">
  <script type="application/javascript"
          src="chrome://mochikit/content/tests/SimpleTest/SimpleTest.js"></script>

  <body xmlns="http://www.w3.org/1999/xhtml" style="height: 300px; overflow: auto;"/>

  <data id="output-birds">
    <listitem anyid="true" label="Barn Owl"/>
    <listitem anyid="true" label="Emu"/>
    <listitem anyid="true" label="Raven"/>
  </data>

  <data id="output-L">
    <listitem anyid="true" label="LAMA"/>
    <listitem anyid="true" label="Lion"/>
  </data>

<script src="templates_shared.js"/>

<script>
<![CDATA[

copyToProfile('animals.sqlite');
SimpleTest.waitForExplicitFinish();


function test_storage_template()
{
  var root = document.getElementById("root1");
  expectedOutput = document.getElementById("output-birds");
  checkResults(root, 0);

root = document.getElementById("root2");
checkResults(root, 0);

root = document.getElementById("root6");
checkResults(root, 0);

root = document.getElementById("root3");
expectedOutput = document.getElementById("output-L");
checkResults(root, 0);

root = document.getElementById("root4");
checkResults(root, 0);

root = document.getElementById("root5");
checkResults(root, 0);

SimpleTest.finish();
}


var testid ="storage listbox with query parameters";
var queryType = "storage";
var isTreeBuilder = false;
var needsOpen = false;
var notWorkingYet = false;
var notWorkingYetDynamic = false;
var expectedOutput;

var changes = [];
]]>
</script>

<listbox  xmlns="http://www.mozilla.org/keymaster/gatekeeper/there.is.only.xul" id="root1" 
              flex="1"  datasources="profile:animals.sqlite" ref="." querytype="storage">
    <template>
        <query>
            SELECT * FROM animals WHERE species_id = ? ORDER BY name
            <param>2</param>
        </query>
        <action>
            <listitem uri="?" label="?name"/>
        </action>
    </template>
</listbox>


<listbox  xmlns="http://www.mozilla.org/keymaster/gatekeeper/there.is.only.xul" id="root2" 
              flex="1"  datasources="profile:animals.sqlite" ref="." querytype="storage">
    <template>
        <query>
            SELECT * FROM animals WHERE species_id = ? ORDER BY name
            <param type="int32">2</param>
        </query>
        <action>
            <listitem uri="?" label="?name"/>
        </action>
    </template>
</listbox>


<listbox  xmlns="http://www.mozilla.org/keymaster/gatekeeper/there.is.only.xul" id="root3" 
              flex="1"  datasources="profile:animals.sqlite" ref="." querytype="storage">
    <template>
        <query>
                SELECT * FROM animals WHERE species_id = :spec AND name like ? ORDER BY name
            <param name="spec" type="int32">5</param>
            <param>L%</param>
        </query>
        <action>
            <listitem uri="?" label="?name"/>
        </action>
    </template>
</listbox>

<listbox  xmlns="http://www.mozilla.org/keymaster/gatekeeper/there.is.only.xul" id="root4" 
              flex="1"  datasources="profile:animals.sqlite" ref="." querytype="storage">
    <template>
        <query>
                SELECT * FROM animals WHERE species_id = ?3 AND name like ?1 ORDER BY name
            <param index="3" type="int32">5</param>
            <param index="1">L%</param>
        </query>
        <action>
            <listitem uri="?" label="?name"/>
        </action>
    </template>
</listbox>

<listbox  xmlns="http://www.mozilla.org/keymaster/gatekeeper/there.is.only.xul" id="root5" 
              flex="1"  datasources="profile:animals.sqlite" ref="." querytype="storage">
    <template>
        <query>
                SELECT * FROM animals WHERE species_id = ?3 AND name like :pattern ORDER BY name
            <param name="pattern">L%</param>
            <param index="3" type="int32">5</param>
        </query>
        <action>
            <listitem uri="?" label="?name"/>
        </action>
    </template>
</listbox>

<listbox  xmlns="http://www.mozilla.org/keymaster/gatekeeper/there.is.only.xul" id="root6" 
              flex="1"  datasources="profile:animals.sqlite" ref="." querytype="storage">
    <template>
        <query>
            SELECT * FROM animals WHERE species_id = ? ORDER BY name
            <param type="int32">2qsdqsd</param>
        </query>
        <action>
            <listitem uri="?" label="?name"/>
        </action>
    </template>
</listbox>



</window>
